QUERY_ALL = "SELECT " \
            "selfInlayGoods.id," \
            "selfInlayGoods.inlay_sn AS inlaySn," \
            "selfInlayGoods.goods_id AS goodsId," \
            "selfInlayGoods.warehouse_id as warehouseId," \
            "warehouse.warehouse_name as warehouseName," \
            "selfInlayGoods.inlay_goods_num as inlayGoodsNum," \
            "selfInlayGoods.inlay_status AS inlaystatus," \
            "CASE inlay_status" \
            " WHEN 0 THEN '待供应链审核'" \
            " WHEN 1 THEN '待供应链回库'" \
            " END AS inlayStatusName," \
            "0 as warehouseInventory" \
            " FROM" \
            " self_inlay_goods selfInlayGoods" \
            " LEFT JOIN warehouse warehouse on warehouse.id=selfInlayGoods.warehouse_id" \
            " WHERE" \
            " selfInlayGoods.if_del =1" \
            " AND selfInlayGoods.inlay_status <= 1"
